Tabela PerfNutrition

Definicja tabeli PerfNutrition

Name

PerfNutrition

Code

PerfNutrition

Comment

 


Lista kolumn tabeli PerfNutrition

Name

Code

PerfNutritionID

PerfNutritionID

NutritionCycleID

NutritionCycleID

NutritionTypeID

NutritionTypeID

NutritionKindID

NutritionKindID

NutritionStatusID

NutritionStatusID

PerfServiceID

PerfServiceID

PerfDT

PerfDT

PerfPersonID

PerfPersonID

NutritionApplicationWayID

NutritionApplicationWayID

NutritionBagNo

NutritionBagNo

NutritionApplicationSpeed

NutritionApplicationSpeed

Comments

Comments

UsePharmacyIntegration

UsePharmacyIntegration


Kolumna PerfNutritionID tabeli PerfNutrition

Definicja kolumny PerfNutritionID tabeli PerfNutrition

Name

PerfNutritionID

Code

PerfNutritionID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Odnotowanie wykonania podania


Kolumna NutritionCycleID tabeli PerfNutrition

Definicja kolumny NutritionCycleID tabeli PerfNutrition

Name

NutritionCycleID

Code

NutritionCycleID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID cyklu zywienia pozajelitowego


Kolumna NutritionTypeID tabeli PerfNutrition

Definicja kolumny NutritionTypeID tabeli PerfNutrition

Name

NutritionTypeID

Code

NutritionTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna NutritionKindID tabeli PerfNutrition

Definicja kolumny NutritionKindID tabeli PerfNutrition

Name

NutritionKindID

Code

NutritionKindID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna NutritionStatusID tabeli PerfNutrition

Definicja kolumny NutritionStatusID tabeli PerfNutrition

Name

NutritionStatusID

Code

NutritionStatusID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PerfServiceID tabeli PerfNutrition

Definicja kolumny PerfServiceID tabeli PerfNutrition

Name

PerfServiceID

Code

PerfServiceID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PerfDT tabeli PerfNutrition

Definicja kolumny PerfDT tabeli PerfNutrition

Name

PerfDT

Code

PerfDT

Data Type

DATE

Mandatory

No

Comment

Data podania


Kolumna PerfPersonID tabeli PerfNutrition

Definicja kolumny PerfPersonID tabeli PerfNutrition

Name

PerfPersonID

Code

PerfPersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

Osoba wykonujaca


Kolumna NutritionApplicationWayID tabeli PerfNutrition

Definicja kolumny NutritionApplicationWayID tabeli PerfNutrition

Name

NutritionApplicationWayID

Code

NutritionApplicationWayID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna NutritionBagNo tabeli PerfNutrition

Definicja kolumny NutritionBagNo tabeli PerfNutrition

Name

NutritionBagNo

Code

NutritionBagNo

Data Type

VARCHAR2(100)

Mandatory

No

Comment

 


Kolumna NutritionApplicationSpeed tabeli PerfNutrition

Definicja kolumny NutritionApplicationSpeed tabeli PerfNutrition

Name

NutritionApplicationSpeed

Code

NutritionApplicationSpeed

Data Type

NUMBER(12,4)

Mandatory

No

Comment

 


Kolumna Comments tabeli PerfNutrition

Definicja kolumny Comments tabeli PerfNutrition

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna UsePharmacyIntegration tabeli PerfNutrition

Definicja kolumny UsePharmacyIntegration tabeli PerfNutrition

Name

UsePharmacyIntegration

Code

UsePharmacyIntegration

Data Type

NUMBER(5)

Mandatory

Yes

Comment

Czy korzysta z integracji z apteka


Lista kluczy tabeli PerfNutrition

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PerfNutrition

Definicja klucza Identifier_1 tabeli PerfNutrition

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment